Name |
|
Code |
|
Comment |
Tabela dla zapisu danych podstawowych karty |
Name |
Code |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
Klucz glówny |
Name |
|
Code |
|
Data Type |
VARCHAR2(20) |
Mandatory |
No |
Comment |
Nr karty |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Etap postepowania |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data sporzadzenia |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Miejsce wydania |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Lekarz wydajacy |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Swiadczeniodawca/jednostka wydajaca |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID pacjenta |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ID opiekuna |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
Flaga wydania karty |
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(3) |
Mandatory |
No |
Comment |
flaga Wystawiono noworodkowi |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
nastepny etap na sciezce onkologicznej (slownik DictionaryID = -941) |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
status karty onkologicznej (link do OncologicCardStatus.OncologicCardStatusID) |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
status etapu karty onkologicznej (link do OncologicCardStageStatus.OncologicCardStageStatusID) |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
status na sciezce onkologicznej |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
ostrzezenie o nieprawidlowych danych |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data decyzji o zalozeniu karty |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Szas od kiedy pacjent jest na sciezce |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|